Laporan Profil Pada Dataset Transjakarta

Dataset statistics

Number of variables	22
Number of observations	37900
Missing cells	14416
Missing cells (%)	1.7%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	6.4 MiB
Average record size in memory	176.0 B

Variable types

Text	8
Numeric	8
Categorical	4
DateTime	2

Alerts

`payCardBank` is highly overall correlated with `payCardID`	High correlation
`payCardID` is highly overall correlated with `payCardBank`	High correlation
`stopEndSeq` is highly overall correlated with `stopStartSeq`	High correlation
`stopStartSeq` is highly overall correlated with `stopEndSeq`	High correlation
`tapInStopsLat` is highly overall correlated with `tapOutStopsLat`	High correlation
`tapInStopsLon` is highly overall correlated with `tapOutStopsLon`	High correlation
`tapOutStopsLat` is highly overall correlated with `tapInStopsLat`	High correlation
`tapOutStopsLon` is highly overall correlated with `tapInStopsLon`	High correlation
`corridorID` has 1257 (3.3%) missing values	Missing
`corridorName` has 1930 (5.1%) missing values	Missing
`tapInStops` has 1213 (3.2%) missing values	Missing
`tapOutStops` has 2289 (6.0%) missing values	Missing
`tapOutStopsName` has 1344 (3.5%) missing values	Missing
`tapOutStopsLat` has 1344 (3.5%) missing values	Missing
`tapOutStopsLon` has 1344 (3.5%) missing values	Missing
`stopEndSeq` has 1344 (3.5%) missing values	Missing
`tapOutTime` has 1344 (3.5%) missing values	Missing
`payAmount` has 1007 (2.7%) missing values	Missing
`transID` has unique values	Unique
`stopStartSeq` has 2920 (7.7%) zeros	Zeros

Reproduction

Analysis started	2023-12-26 16:52:50.675452
Analysis finished	2023-12-26 16:53:22.796301
Duration	32.12 seconds
Software version	ydata-profiling vv4.6.3
Download configuration	config.json

transID
Text

UNIQUE

Distinct	37900
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Memory size	296.2 KiB

Length

Max length	14
Median length	14
Mean length	14
Min length	14

Characters and Unicode

Total characters	530600
Distinct characters	36
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	37900 ?
Unique (%)	100.0%

Sample

1st row	EIIW227B8L34VB
2nd row	LGXO740D2N47GZ
3rd row	DJWR385V2U57TO
4th row	JTUZ800U7C86EH
5th row	VMLO535V7F95NJ

Value	Count	Frequency (%)
eiiw227b8l34vb	1	< 0.1%
zyrl615g4c05rd	1	< 0.1%
cupo258c0d42py	1	< 0.1%
oihs248v7s72eb	1	< 0.1%
djwr385v2u57to	1	< 0.1%
jtuz800u7c86eh	1	< 0.1%
vmlo535v7f95nj	1	< 0.1%
ddes630k2f80kc	1	< 0.1%
hemw326b9n91tv	1	< 0.1%
xtke052e5e87ln	1	< 0.1%
Other values (37890)	37890	> 99.9%

Most occurring characters

Value	Count	Frequency (%)
5	22949	4.3%
6	22881	4.3%
8	22860	4.3%
9	22832	4.3%
4	22718	4.3%
3	22714	4.3%
1	22673	4.3%
7	22652	4.3%
2	22602	4.3%
0	22519	4.2%
Other values (26)	303200	57.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	303200	57.1%
Decimal Number	227400	42.9%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
B	11788	3.9%
C	11741	3.9%
D	11736	3.9%
R	11735	3.9%
S	11720	3.9%
U	11714	3.9%
K	11709	3.9%
P	11706	3.9%
J	11702	3.9%
Y	11701	3.9%
Other values (16)	185948	61.3%

Decimal Number

Value	Count	Frequency (%)
5	22949	10.1%
6	22881	10.1%
8	22860	10.1%
9	22832	10.0%
4	22718	10.0%
3	22714	10.0%
1	22673	10.0%
7	22652	10.0%
2	22602	9.9%
0	22519	9.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	303200	57.1%
Common	227400	42.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
B	11788	3.9%
C	11741	3.9%
D	11736	3.9%
R	11735	3.9%
S	11720	3.9%
U	11714	3.9%
K	11709	3.9%
P	11706	3.9%
J	11702	3.9%
Y	11701	3.9%
Other values (16)	185948	61.3%

Common

Value	Count	Frequency (%)
5	22949	10.1%
6	22881	10.1%
8	22860	10.1%
9	22832	10.0%
4	22718	10.0%
3	22714	10.0%
1	22673	10.0%
7	22652	10.0%
2	22602	9.9%
0	22519	9.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	530600	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
5	22949	4.3%
6	22881	4.3%
8	22860	4.3%
9	22832	4.3%
4	22718	4.3%
3	22714	4.3%
1	22673	4.3%
7	22652	4.3%
2	22602	4.3%
0	22519	4.2%
Other values (26)	303200	57.1%

payCardID
Real number (ℝ)

HIGH CORRELATION

Distinct	2000
Distinct (%)	5.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.2500603 × 10¹⁷

Minimum	6.0403675 × 10¹⁰
Maximum	4.9976939 × 10¹⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	296.2 KiB

Quantile statistics

Minimum	6.0403675 × 10¹⁰
5-th percentile	5.8905739 × 10¹¹
Q1	1.8004424 × 10¹⁴
median	3.5079466 × 10¹⁵
Q3	4.6990232 × 10¹⁵
95-th percentile	4.4893373 × 10¹⁸
Maximum	4.9976939 × 10¹⁸
Range	4.9976939 × 10¹⁸
Interquartile range (IQR)	4.518979 × 10¹⁵

Descriptive statistics

Standard deviation	1.3216987 × 10¹⁸
Coefficient of variation (CV)	3.1098351
Kurtosis	6.0289022
Mean	4.2500603 × 10¹⁷
Median Absolute Deviation (MAD)	3.1293927 × 10¹⁵
Skewness	2.8237921
Sum	3.7209551 × 10¹⁸
Variance	1.7468874 × 10³⁶
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.800626598 × 10¹⁴	40	0.1%
2.273899077 × 10¹⁵	40	0.1%
3.533955956 × 10¹⁵	40	0.1%
5.250092672 × 10¹⁵	40	0.1%
4.739532514 × 10¹⁵	40	0.1%
3.480568175 × 10¹⁴	40	0.1%
3.721868523 × 10¹⁴	40	0.1%
3.014600091 × 10¹³	40	0.1%
4.489337334 × 10¹⁸	40	0.1%
2.259163638 × 10¹⁵	40	0.1%
Other values (1990)	37500	98.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
6.040367544 × 10¹⁰	40	0.1%
6.04044987 × 10¹⁰	40	0.1%
6.041702093 × 10¹⁰	4	< 0.1%
6.042120834 × 10¹⁰	4	< 0.1%
6.04275394 × 10¹⁰	1	< 0.1%
6.043882318 × 10¹⁰	4	< 0.1%
6.045913992 × 10¹⁰	1	< 0.1%
6.047717301 × 10¹⁰	4	< 0.1%
5.018263064 × 10¹¹	1	< 0.1%
5.018281295 × 10¹¹	40	0.1%

Value	Count	Frequency (%)
4.997693931 × 10¹⁸	40	0.1%
4.995586293 × 10¹⁸	4	< 0.1%
4.986663118 × 10¹⁸	40	0.1%
4.980564692 × 10¹⁸	14	< 0.1%
4.980316891 × 10¹⁸	4	< 0.1%
4.980154954 × 10¹⁸	40	0.1%
4.965463576 × 10¹⁸	40	0.1%
4.963710913 × 10¹⁸	40	0.1%
4.958145745 × 10¹⁸	40	0.1%
4.957958811 × 10¹⁸	40	0.1%

payCardBank
Categorical

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	296.2 KiB

dki	18743
emoney	6866
brizzi	3531
flazz	3234
online	2869

Length

Max length	6
Median length	3
Mean length	4.2207388
Min length	3

Characters and Unicode

Total characters	159966
Distinct characters	14
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	emoney
2nd row	dki
3rd row	dki
4th row	flazz
5th row	flazz

Common Values

Value	Count	Frequency (%)
dki	18743	49.5%
emoney	6866	18.1%
brizzi	3531	9.3%
flazz	3234	8.5%
online	2869	7.6%
bni	2657	7.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
dki	18743	49.5%
emoney	6866	18.1%
brizzi	3531	9.3%
flazz	3234	8.5%
online	2869	7.6%
bni	2657	7.0%

Most occurring characters

Value	Count	Frequency (%)
i	31331	19.6%
d	18743	11.7%
k	18743	11.7%
e	16601	10.4%
n	15261	9.5%
z	13530	8.5%
o	9735	6.1%
m	6866	4.3%
y	6866	4.3%
b	6188	3.9%
Other values (4)	16102	10.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	159966	100.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
i	31331	19.6%
d	18743	11.7%
k	18743	11.7%
e	16601	10.4%
n	15261	9.5%
z	13530	8.5%
o	9735	6.1%
m	6866	4.3%
y	6866	4.3%
b	6188	3.9%
Other values (4)	16102	10.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	159966	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
i	31331	19.6%
d	18743	11.7%
k	18743	11.7%
e	16601	10.4%
n	15261	9.5%
z	13530	8.5%
o	9735	6.1%
m	6866	4.3%
y	6866	4.3%
b	6188	3.9%
Other values (4)	16102	10.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	159966	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
i	31331	19.6%
d	18743	11.7%
k	18743	11.7%
e	16601	10.4%
n	15261	9.5%
z	13530	8.5%
o	9735	6.1%
m	6866	4.3%
y	6866	4.3%
b	6188	3.9%
Other values (4)	16102	10.1%

payCardName
Text

Distinct	1993
Distinct (%)	5.3%
Missing	0
Missing (%)	0.0%
Memory size	296.2 KiB

Length

Max length	34
Median length	29
Mean length	17.271768
Min length	9

Characters and Unicode

Total characters	654600
Distinct characters	54
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	299 ?
Unique (%)	0.8%

Sample

1st row	Bajragin Usada
2nd row	Gandi Widodo
3rd row	Emong Wastuti
4th row	Surya Wacana
5th row	Embuh Mardhiyah

Value	Count	Frequency (%)
dr	1877	1.9%
drg	1115	1.2%
tgk	1037	1.1%
drs	962	1.0%
m.m	888	0.9%
r	795	0.8%
s.sos	656	0.7%
s.kom	639	0.7%
ir	613	0.6%
siregar	586	0.6%
Other values (828)	87534	90.5%

Most occurring characters

Value	Count	Frequency (%)
a	112901	17.2%
	58802	9.0%
i	54931	8.4%
r	37377	5.7%
n	37275	5.7%
t	26056	4.0%
.	24535	3.7%
u	23566	3.6%
s	20840	3.2%
d	18004	2.8%
Other values (44)	240313	36.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	453448	69.3%
Uppercase Letter	107652	16.4%
Space Separator	58802	9.0%
Other Punctuation	34698	5.3%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	16167	15.0%
M	10465	9.7%
P	9957	9.2%
H	7349	6.8%
K	5750	5.3%
R	5301	4.9%
A	5131	4.8%
D	4897	4.5%
N	4897	4.5%
I	4321	4.0%
Other values (16)	33417	31.0%

Lowercase Letter

Value	Count	Frequency (%)
a	112901	24.9%
i	54931	12.1%
r	37377	8.2%
n	37275	8.2%
t	26056	5.7%
u	23566	5.2%
s	20840	4.6%
d	18004	4.0%
o	16782	3.7%
m	16609	3.7%
Other values (15)	89107	19.7%

Other Punctuation

Value	Count	Frequency (%)
.	24535	70.7%
,	10163	29.3%

Space Separator

Value	Count	Frequency (%)
	58802	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	561100	85.7%
Common	93500	14.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	112901	20.1%
i	54931	9.8%
r	37377	6.7%
n	37275	6.6%
t	26056	4.6%
u	23566	4.2%
s	20840	3.7%
d	18004	3.2%
o	16782	3.0%
m	16609	3.0%
Other values (41)	196759	35.1%

Common

Value	Count	Frequency (%)
	58802	62.9%
.	24535	26.2%
,	10163	10.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	654600	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	112901	17.2%
	58802	9.0%
i	54931	8.4%
r	37377	5.7%
n	37275	5.7%
t	26056	4.0%
.	24535	3.7%
u	23566	3.6%
s	20840	3.2%
d	18004	2.8%
Other values (44)	240313	36.7%

payCardSex
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	296.2 KiB

F	20157
M	17743

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	37900
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	M
2nd row	F
3rd row	F
4th row	F
5th row	M

Common Values

Value	Count	Frequency (%)
F	20157	53.2%
M	17743	46.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
f	20157	53.2%
m	17743	46.8%

Most occurring characters

Value	Count	Frequency (%)
F	20157	53.2%
M	17743	46.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	37900	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
F	20157	53.2%
M	17743	46.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	37900	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
F	20157	53.2%
M	17743	46.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	37900	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
F	20157	53.2%
M	17743	46.8%

payCardBirthDate
Real number (ℝ)

Distinct	67
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1990.0893

Minimum	1946
Maximum	2012
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	296.2 KiB

Quantile statistics

Minimum	1946
5-th percentile	1967
Q1	1982
median	1990
Q3	2001
95-th percentile	2010
Maximum	2012
Range	66
Interquartile range (IQR)	19

Descriptive statistics

Standard deviation	13.051482
Coefficient of variation (CV)	0.0065582394
Kurtosis	-0.032965724
Mean	1990.0893
Median Absolute Deviation (MAD)	9
Skewness	-0.41338542
Sum	75424385
Variance	170.34119
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1992	1394	3.7%
1981	1381	3.6%
1994	1355	3.6%
1987	1291	3.4%
1985	1251	3.3%
1984	1218	3.2%
1983	1186	3.1%
1989	1170	3.1%
1996	1140	3.0%
1991	1130	3.0%
Other values (57)	25384	67.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1946	120	0.3%
1947	18	< 0.1%
1948	85	0.2%
1949	8	< 0.1%
1950	1	< 0.1%
1951	49	0.1%
1952	19	0.1%
1953	40	0.1%
1954	4	< 0.1%
1955	5	< 0.1%

Value	Count	Frequency (%)
2012	800	2.1%
2011	730	1.9%
2010	747	2.0%
2009	754	2.0%
2008	880	2.3%
2007	808	2.1%
2006	693	1.8%
2005	711	1.9%
2004	906	2.4%
2003	935	2.5%

corridorID
Text

MISSING

Distinct	221
Distinct (%)	0.6%
Missing	1257
Missing (%)	3.3%
Memory size	296.2 KiB

Length

Max length	8
Median length	7
Mean length	3.7205196
Min length	1

Characters and Unicode

Total characters	136331
Distinct characters	32
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	5
2nd row	6C
3rd row	R1A
4th row	11D
5th row	12

Value	Count	Frequency (%)
1t	400	1.1%
s21	388	1.1%
jis3	341	0.9%
8c	339	0.9%
jak.06	333	0.9%
11p	332	0.9%
2e	318	0.9%
9d	310	0.8%
m7b	309	0.8%
jak.72	305	0.8%
Other values (211)	33268	90.8%

Most occurring characters

Value	Count	Frequency (%)
1	18143	13.3%
A	15451	11.3%
K	14129	10.4%
J	13785	10.1%
.	13444	9.9%
2	7406	5.4%
3	6088	4.5%
4	5141	3.8%
6	4559	3.3%
0	4224	3.1%
Other values (22)	33961	24.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	63602	46.7%
Decimal Number	59285	43.5%
Other Punctuation	13444	9.9%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	15451	24.3%
K	14129	22.2%
J	13785	21.7%
B	3070	4.8%
M	2730	4.3%
D	2294	3.6%
C	2222	3.5%
E	1305	2.1%
S	1235	1.9%
H	1105	1.7%
Other values (11)	6276	9.9%

Decimal Number

Value	Count	Frequency (%)
1	18143	30.6%
2	7406	12.5%
3	6088	10.3%
4	5141	8.7%
6	4559	7.7%
0	4224	7.1%
8	3822	6.4%
7	3705	6.2%
5	3440	5.8%
9	2757	4.7%

Other Punctuation

Value	Count	Frequency (%)
.	13444	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	72729	53.3%
Latin	63602	46.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	15451	24.3%
K	14129	22.2%
J	13785	21.7%
B	3070	4.8%
M	2730	4.3%
D	2294	3.6%
C	2222	3.5%
E	1305	2.1%
S	1235	1.9%
H	1105	1.7%
Other values (11)	6276	9.9%

Common

Value	Count	Frequency (%)
1	18143	24.9%
.	13444	18.5%
2	7406	10.2%
3	6088	8.4%
4	5141	7.1%
6	4559	6.3%
0	4224	5.8%
8	3822	5.3%
7	3705	5.1%
5	3440	4.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	136331	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	18143	13.3%
A	15451	11.3%
K	14129	10.4%
J	13785	10.1%
.	13444	9.9%
2	7406	5.4%
3	6088	4.5%
4	5141	3.8%
6	4559	3.3%
0	4224	3.1%
Other values (22)	33961	24.9%

corridorName
Text

MISSING

Distinct	216
Distinct (%)	0.6%
Missing	1930
Missing (%)	5.1%
Memory size	296.2 KiB

Length

Max length	51
Median length	40
Mean length	26.138782
Min length	11

Characters and Unicode

Total characters	940212
Distinct characters	51
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Matraman Baru - Ancol
2nd row	Stasiun Tebet - Karet via Patra Kuningan
3rd row	Pantai Maju - Kota
4th row	Pulo Gebang - Pulo Gadung 2 via PIK
5th row	Tanjung Priok - Pluit

Value	Count	Frequency (%)
	36329	21.1%
via	4214	2.4%
pulo	4108	2.4%
kampung	4070	2.4%
rusun	3838	2.2%
m	3135	1.8%
blok	3135	1.8%
tanah	2981	1.7%
gadung	2596	1.5%
abang	2527	1.5%
Other values (241)	105345	61.1%

Most occurring characters

Value	Count	Frequency (%)
	136308	14.5%
a	128608	13.7%
n	85832	9.1%
u	54979	5.8%
i	42976	4.6%
e	38167	4.1%
-	36329	3.9%
r	34290	3.6%
g	33034	3.5%
o	29306	3.1%
Other values (41)	320383	34.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	623275	66.3%
Uppercase Letter	139427	14.8%
Space Separator	136308	14.5%
Dash Punctuation	36329	3.9%
Decimal Number	2252	0.2%
Other Punctuation	1503	0.2%
Open Punctuation	559	0.1%
Close Punctuation	559	0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	128608	20.6%
n	85832	13.8%
u	54979	8.8%
i	42976	6.9%
e	38167	6.1%
r	34290	5.5%
g	33034	5.3%
o	29306	4.7%
l	27736	4.5%
t	25491	4.1%
Other values (13)	122856	19.7%

Uppercase Letter

Value	Count	Frequency (%)
P	20451	14.7%
K	16476	11.8%
B	15667	11.2%
T	13206	9.5%
R	13067	9.4%
M	10655	7.6%
S	9186	6.6%
G	8372	6.0%
C	7834	5.6%
A	5232	3.8%
Other values (11)	19281	13.8%

Decimal Number

Value	Count	Frequency (%)
2	2098	93.2%
1	154	6.8%

Space Separator

Value	Count	Frequency (%)
	136308	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	36329	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	1503	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	559	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	559	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	762702	81.1%
Common	177510	18.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	128608	16.9%
n	85832	11.3%
u	54979	7.2%
i	42976	5.6%
e	38167	5.0%
r	34290	4.5%
g	33034	4.3%
o	29306	3.8%
l	27736	3.6%
t	25491	3.3%
Other values (34)	262283	34.4%

Common

Value	Count	Frequency (%)
	136308	76.8%
-	36329	20.5%
2	2098	1.2%
.	1503	0.8%
(	559	0.3%
)	559	0.3%
1	154	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	940212	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	136308	14.5%
a	128608	13.7%
n	85832	9.1%
u	54979	5.8%
i	42976	4.6%
e	38167	4.1%
-	36329	3.9%
r	34290	3.6%
g	33034	3.5%
o	29306	3.1%
Other values (41)	320383	34.1%

direction
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	296.2 KiB

1.0	18974
0.0	18926

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	113700
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
1.0	18974	50.1%
0.0	18926	49.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	18974	50.1%
0.0	18926	49.9%

Most occurring characters

Value	Count	Frequency (%)
0	56826	50.0%
.	37900	33.3%
1	18974	16.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	75800	66.7%
Other Punctuation	37900	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	56826	75.0%
1	18974	25.0%

Other Punctuation

Value	Count	Frequency (%)
.	37900	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	113700	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	56826	50.0%
.	37900	33.3%
1	18974	16.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	113700	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	56826	50.0%
.	37900	33.3%
1	18974	16.7%

tapInStops
Text

MISSING

Distinct	2570
Distinct (%)	7.0%
Missing	1213
Missing (%)	3.2%
Memory size	296.2 KiB

Length

Max length	7
Median length	7
Mean length	6.7263881
Min length	6

Characters and Unicode

Total characters	246771
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	910 ?
Unique (%)	2.5%

Sample

1st row	P00142
2nd row	B01963P
3rd row	B00499P
4th row	B05587P
5th row	P00239

Value	Count	Frequency (%)
p00170	236	0.6%
p00064	200	0.5%
p00016	170	0.5%
p00297	151	0.4%
p00164	145	0.4%
b00248p	130	0.4%
p00169	127	0.3%
p00221	123	0.3%
b03277p	122	0.3%
p00254	122	0.3%
Other values (2560)	35161	95.8%

Most occurring characters

Value	Count	Frequency (%)
0	66069	26.8%
P	36687	14.9%
B	26649	10.8%
2	17683	7.2%
1	17304	7.0%
5	13878	5.6%
3	13846	5.6%
6	12529	5.1%
4	12459	5.0%
8	10518	4.3%
Other values (2)	19149	7.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	183435	74.3%
Uppercase Letter	63336	25.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	66069	36.0%
2	17683	9.6%
1	17304	9.4%
5	13878	7.6%
3	13846	7.5%
6	12529	6.8%
4	12459	6.8%
8	10518	5.7%
7	10267	5.6%
9	8882	4.8%

Uppercase Letter

Value	Count	Frequency (%)
P	36687	57.9%
B	26649	42.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	183435	74.3%
Latin	63336	25.7%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	66069	36.0%
2	17683	9.6%
1	17304	9.4%
5	13878	7.6%
3	13846	7.5%
6	12529	6.8%
4	12459	6.8%
8	10518	5.7%
7	10267	5.6%
9	8882	4.8%

Latin

Value	Count	Frequency (%)
P	36687	57.9%
B	26649	42.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	246771	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	66069	26.8%
P	36687	14.9%
B	26649	10.8%
2	17683	7.2%
1	17304	7.0%
5	13878	5.6%
3	13846	5.6%
6	12529	5.1%
4	12459	5.0%
8	10518	4.3%
Other values (2)	19149	7.8%

tapInStopsName
Text

Distinct	2602
Distinct (%)	6.9%
Missing	0
Missing (%)	0.0%
Memory size	296.2 KiB

Length

Max length	41
Median length	33
Mean length	16.584354
Min length	3

Characters and Unicode

Total characters	628547
Distinct characters	66
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	929 ?
Unique (%)	2.5%

Sample

1st row	Pal Putih
2nd row	Kemenkes 2
3rd row	Gg. Kunir II
4th row	Taman Elok 1
5th row	Sunter Boulevard Barat

Value	Count	Frequency (%)
jln	4613	4.2%
2	3678	3.3%
1	3526	3.2%
sbr	3456	3.1%
barat	1445	1.3%
timur	1395	1.3%
arah	1257	1.1%
simpang	1254	1.1%
raya	1142	1.0%
gg	1074	1.0%
Other values (1904)	87231	79.2%

Most occurring characters

Value	Count	Frequency (%)
a	87431	13.9%
	72171	11.5%
n	45026	7.2%
r	33345	5.3%
i	30172	4.8%
e	27831	4.4%
u	23586	3.8%
l	20324	3.2%
t	19482	3.1%
g	17587	2.8%
Other values (56)	251592	40.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	414716	66.0%
Uppercase Letter	117986	18.8%
Space Separator	72171	11.5%
Other Punctuation	12204	1.9%
Decimal Number	11399	1.8%
Dash Punctuation	71	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	87431	21.1%
n	45026	10.9%
r	33345	8.0%
i	30172	7.3%
e	27831	6.7%
u	23586	5.7%
l	20324	4.9%
t	19482	4.7%
g	17587	4.2%
m	16486	4.0%
Other values (16)	93446	22.5%

Uppercase Letter

Value	Count	Frequency (%)
S	15164	12.9%
P	13315	11.3%
B	9444	8.0%
K	9316	7.9%
J	8940	7.6%
M	8498	7.2%
T	7768	6.6%
R	6223	5.3%
A	6074	5.1%
I	6032	5.1%
Other values (16)	27212	23.1%

Decimal Number

Value	Count	Frequency (%)
1	4141	36.3%
2	4028	35.3%
0	783	6.9%
3	693	6.1%
5	566	5.0%
7	334	2.9%
4	327	2.9%
8	211	1.9%
6	200	1.8%
9	116	1.0%

Other Punctuation

Value	Count	Frequency (%)
.	12198	> 99.9%
/	6	< 0.1%

Space Separator

Value	Count	Frequency (%)
	72171	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	71	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	532702	84.8%
Common	95845	15.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	87431	16.4%
n	45026	8.5%
r	33345	6.3%
i	30172	5.7%
e	27831	5.2%
u	23586	4.4%
l	20324	3.8%
t	19482	3.7%
g	17587	3.3%
m	16486	3.1%
Other values (42)	211432	39.7%

Common

Value	Count	Frequency (%)
	72171	75.3%
.	12198	12.7%
1	4141	4.3%
2	4028	4.2%
0	783	0.8%
3	693	0.7%
5	566	0.6%
7	334	0.3%
4	327	0.3%
8	211	0.2%
Other values (4)	393	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	628547	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	87431	13.9%
	72171	11.5%
n	45026	7.2%
r	33345	5.3%
i	30172	4.8%
e	27831	4.4%
u	23586	3.8%
l	20324	3.2%
t	19482	3.1%
g	17587	2.8%
Other values (56)	251592	40.0%

tapInStopsLat
Real number (ℝ)

HIGH CORRELATION

Distinct	2587
Distinct (%)	6.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-6.2148379

Minimum	-6.394973
Maximum	-6.089429
Zeros	0
Zeros (%)	0.0%
Negative	37900
Negative (%)	100.0%
Memory size	296.2 KiB

Quantile statistics

Minimum	-6.394973
5-th percentile	-6.3126762
Q1	-6.245863
median	-6.214587
Q3	-6.175528
95-th percentile	-6.120279
Maximum	-6.089429
Range	0.305544
Interquartile range (IQR)	0.070335

Descriptive statistics

Standard deviation	0.057911227
Coefficient of variation (CV)	-0.00931822
Kurtosis	-0.24023203
Mean	-6.2148379
Median Absolute Deviation (MAD)	0.035872
Skewness	-0.25374441
Sum	-235542.36
Variance	0.0033537102
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-6.126306	243	0.6%
-6.290154	208	0.5%
-6.257751	173	0.5%
-6.245863	155	0.4%
-6.278404	152	0.4%
-6.214132	137	0.4%
-6.368735	133	0.4%
-6.135667	131	0.3%
-6.240213	126	0.3%
-6.238064	126	0.3%
Other values (2577)	36316	95.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-6.394973	40	0.1%
-6.387532	8	< 0.1%
-6.387291	22	0.1%
-6.384603	2	< 0.1%
-6.382532	1	< 0.1%
-6.381864	1	< 0.1%
-6.380018	1	< 0.1%
-6.379677	1	< 0.1%
-6.379631	7	< 0.1%
-6.379606	1	< 0.1%

Value	Count	Frequency (%)
-6.089429	20	0.1%
-6.091746	20	0.1%
-6.091992	1	< 0.1%
-6.093258	5	< 0.1%
-6.093637	63	0.2%
-6.096407	1	< 0.1%
-6.097099	20	0.1%
-6.097476	2	< 0.1%
-6.09791	8	< 0.1%
-6.098023	1	< 0.1%

tapInStopsLon
Real number (ℝ)

HIGH CORRELATION

Distinct	2458
Distinct (%)	6.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	106.84155

Minimum	106.61473
Maximum	107.02395
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	296.2 KiB

Quantile statistics

Minimum	106.61473
5-th percentile	106.74598
Q1	106.80347
median	106.83483
Q3	106.88227
95-th percentile	106.93961
Maximum	107.02395
Range	0.40922
Interquartile range (IQR)	0.0788

Descriptive statistics

Standard deviation	0.060369455
Coefficient of variation (CV)	0.00056503722
Kurtosis	0.58176478
Mean	106.84155
Median Absolute Deviation (MAD)	0.039245
Skewness	-0.11928473
Sum	4049294.9
Variance	0.0036444711
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
106.79203	243	0.6%
106.88116	208	0.5%
106.87	173	0.5%
106.871143	155	0.4%
106.82972	152	0.4%
106.89366	133	0.4%
106.76299	131	0.3%
106.93961	130	0.3%
106.83102	127	0.3%
106.81624	127	0.3%
Other values (2448)	36321	95.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
106.61473	41	0.1%
106.61667	1	< 0.1%
106.61807	21	0.1%
106.61882	20	0.1%
106.61888	1	< 0.1%
106.61931	1	< 0.1%
106.61943	1	< 0.1%
106.62023	21	0.1%
106.62026	21	0.1%
106.62391	21	0.1%

Value	Count	Frequency (%)
107.02395	21	0.1%
107.02384	20	0.1%
107.02303	20	0.1%
107.02206	20	0.1%
107.02153	20	0.1%
107.02149	1	< 0.1%
107.02075	1	< 0.1%
107.02069	27	0.1%
107.0206	20	0.1%
107.01987	8	< 0.1%

stopStartSeq
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	67
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	13.57248

Minimum	0
Maximum	68
Zeros	2920
Zeros (%)	7.7%
Negative	0
Negative (%)	0.0%
Memory size	296.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	4
median	10
Q3	19
95-th percentile	39
Maximum	68
Range	68
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	12.237623
Coefficient of variation (CV)	0.9016497
Kurtosis	1.2655431
Mean	13.57248
Median Absolute Deviation (MAD)	7
Skewness	1.2444309
Sum	514397
Variance	149.75941
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2920	7.7%
2	2026	5.3%
4	1792	4.7%
5	1789	4.7%
1	1683	4.4%
3	1612	4.3%
11	1590	4.2%
6	1527	4.0%
8	1521	4.0%
7	1519	4.0%
Other values (57)	19921	52.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2920	7.7%
1	1683	4.4%
2	2026	5.3%
3	1612	4.3%
4	1792	4.7%
5	1789	4.7%
6	1527	4.0%
7	1519	4.0%
8	1521	4.0%
9	1370	3.6%

Value	Count	Frequency (%)
68	8	< 0.1%
66	1	< 0.1%
65	21	0.1%
64	2	< 0.1%
63	8	< 0.1%
62	41	0.1%
61	28	0.1%
59	2	< 0.1%
58	25	0.1%
57	41	0.1%

tapInTime
Date

Distinct	37079
Distinct (%)	97.8%
Missing	0
Missing (%)	0.0%
Memory size	296.2 KiB

Minimum	2023-04-01 06:22:27
Maximum	2023-04-30 21:55:41

Histogram

Histogram with fixed size bins (bins=50)

tapOutStops
Text

MISSING

Distinct	2230
Distinct (%)	6.3%
Missing	2289
Missing (%)	6.0%
Memory size	296.2 KiB

Length

Max length	7
Median length	7
Mean length	6.7137963
Min length	6

Characters and Unicode

Total characters	239085
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	762 ?
Unique (%)	2.1%

Sample

1st row	P00253
2nd row	B03307P
3rd row	B04962P
4th row	B03090P
5th row	P00098

Value	Count	Frequency (%)
p00016	306	0.9%
p00170	255	0.7%
b05725p	189	0.5%
p00137	161	0.5%
b05708p	158	0.4%
p00112	158	0.4%
p00199	146	0.4%
p00179	140	0.4%
b03396p	131	0.4%
p00254	127	0.4%
Other values (2220)	33840	95.0%

Most occurring characters

Value	Count	Frequency (%)
0	63397	26.5%
P	35611	14.9%
B	25419	10.6%
2	17413	7.3%
1	17293	7.2%
5	13730	5.7%
3	13119	5.5%
6	11737	4.9%
4	11539	4.8%
7	10385	4.3%
Other values (2)	19442	8.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	178055	74.5%
Uppercase Letter	61030	25.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	63397	35.6%
2	17413	9.8%
1	17293	9.7%
5	13730	7.7%
3	13119	7.4%
6	11737	6.6%
4	11539	6.5%
7	10385	5.8%
8	10132	5.7%
9	9310	5.2%

Uppercase Letter

Value	Count	Frequency (%)
P	35611	58.3%
B	25419	41.7%

Most occurring scripts

Value	Count	Frequency (%)
Common	178055	74.5%
Latin	61030	25.5%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	63397	35.6%
2	17413	9.8%
1	17293	9.7%
5	13730	7.7%
3	13119	7.4%
6	11737	6.6%
4	11539	6.5%
7	10385	5.8%
8	10132	5.7%
9	9310	5.2%

Latin

Value	Count	Frequency (%)
P	35611	58.3%
B	25419	41.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	239085	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	63397	26.5%
P	35611	14.9%
B	25419	10.6%
2	17413	7.3%
1	17293	7.2%
5	13730	5.7%
3	13119	5.5%
6	11737	4.9%
4	11539	4.8%
7	10385	4.3%
Other values (2)	19442	8.1%

tapOutStopsName
Text

MISSING

Distinct	2248
Distinct (%)	6.1%
Missing	1344
Missing (%)	3.5%
Memory size	296.2 KiB

Length

Max length	42
Median length	33
Mean length	16.333981
Min length	3

Characters and Unicode

Total characters	597105
Distinct characters	66
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	775 ?
Unique (%)	2.1%

Sample

1st row	Tegalan
2nd row	Sampoerna Strategic
3rd row	Simpang Kunir Kemukus
4th row	Raya Penggilingan
5th row	Kali Besar Barat

Value	Count	Frequency (%)
2	3890	3.7%
jln	3777	3.6%
1	3021	2.9%
sbr	2784	2.7%
simpang	1577	1.5%
raya	1214	1.2%
timur	1164	1.1%
barat	1094	1.0%
arah	1088	1.0%
masjid	946	0.9%
Other values (1723)	84259	80.4%

Most occurring characters

Value	Count	Frequency (%)
a	83372	14.0%
	68258	11.4%
n	43100	7.2%
r	30886	5.2%
i	27619	4.6%
e	25535	4.3%
u	24042	4.0%
t	18885	3.2%
l	18730	3.1%
g	17653	3.0%
Other values (56)	239025	40.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	393778	65.9%
Uppercase Letter	112800	18.9%
Space Separator	68258	11.4%
Other Punctuation	11436	1.9%
Decimal Number	10816	1.8%
Dash Punctuation	17	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	83372	21.2%
n	43100	10.9%
r	30886	7.8%
i	27619	7.0%
e	25535	6.5%
u	24042	6.1%
t	18885	4.8%
l	18730	4.8%
g	17653	4.5%
m	17013	4.3%
Other values (16)	86943	22.1%

Uppercase Letter

Value	Count	Frequency (%)
S	14484	12.8%
P	13448	11.9%
K	9432	8.4%
J	8286	7.3%
B	8164	7.2%
T	8080	7.2%
M	7852	7.0%
R	7074	6.3%
I	5749	5.1%
A	5717	5.1%
Other values (15)	24514	21.7%

Decimal Number

Value	Count	Frequency (%)
2	4359	40.3%
1	3433	31.7%
3	844	7.8%
0	633	5.9%
5	358	3.3%
4	352	3.3%
7	295	2.7%
8	243	2.2%
6	161	1.5%
9	138	1.3%

Other Punctuation

Value	Count	Frequency (%)
.	11434	> 99.9%
&	1	< 0.1%
/	1	< 0.1%

Space Separator

Value	Count	Frequency (%)
	68258	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	17	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	506578	84.8%
Common	90527	15.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	83372	16.5%
n	43100	8.5%
r	30886	6.1%
i	27619	5.5%
e	25535	5.0%
u	24042	4.7%
t	18885	3.7%
l	18730	3.7%
g	17653	3.5%
m	17013	3.4%
Other values (41)	199743	39.4%

Common

Value	Count	Frequency (%)
	68258	75.4%
.	11434	12.6%
2	4359	4.8%
1	3433	3.8%
3	844	0.9%
0	633	0.7%
5	358	0.4%
4	352	0.4%
7	295	0.3%
8	243	0.3%
Other values (5)	318	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	597105	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	83372	14.0%
	68258	11.4%
n	43100	7.2%
r	30886	5.2%
i	27619	4.6%
e	25535	4.3%
u	24042	4.0%
t	18885	3.2%
l	18730	3.1%
g	17653	3.0%
Other values (56)	239025	40.0%

tapOutStopsLat
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	2237
Distinct (%)	6.1%
Missing	1344
Missing (%)	3.5%
Infinite	0
Infinite (%)	0.0%
Mean	-6.2146513

Minimum	-6.394973
Maximum	-6.091746
Zeros	0
Zeros (%)	0.0%
Negative	36556
Negative (%)	96.5%
Memory size	296.2 KiB

Quantile statistics

Minimum	-6.394973
5-th percentile	-6.3125753
Q1	-6.247225
median	-6.214718
Q3	-6.174736
95-th percentile	-6.116512
Maximum	-6.091746
Range	0.303227
Interquartile range (IQR)	0.072489

Descriptive statistics

Standard deviation	0.059022026
Coefficient of variation (CV)	-0.0094972385
Kurtosis	-0.34313281
Mean	-6.2146513
Median Absolute Deviation (MAD)	0.03847
Skewness	-0.22590932
Sum	-227182.79
Variance	0.0034835995
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-6.257751	316	0.8%
-6.126306	265	0.7%
-6.17356	196	0.5%
-6.176248	167	0.4%
-6.308964	164	0.4%
-6.2405	159	0.4%
-6.305769	151	0.4%
-6.291075	146	0.4%
-6.224688	131	0.3%
-6.115795	131	0.3%
Other values (2227)	34730	91.6%
(Missing)	1344	3.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-6.394973	1	< 0.1%
-6.391068	45	0.1%
-6.387532	1	< 0.1%
-6.383095	1	< 0.1%
-6.382532	1	< 0.1%
-6.381864	1	< 0.1%
-6.380896	2	< 0.1%
-6.380018	19	0.1%
-6.379679	7	< 0.1%
-6.379677	1	< 0.1%

Value	Count	Frequency (%)
-6.091746	25	0.1%
-6.092201	41	0.1%
-6.093258	21	0.1%
-6.093637	77	0.2%
-6.094772	2	< 0.1%
-6.097099	26	0.1%
-6.09791	20	0.1%
-6.098204	20	0.1%
-6.09826	25	0.1%
-6.099616	1	< 0.1%

tapOutStopsLon
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	2139
Distinct (%)	5.9%
Missing	1344
Missing (%)	3.5%
Infinite	0
Infinite (%)	0.0%
Mean	106.84123

Minimum	106.61473
Maximum	107.02366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	296.2 KiB

Quantile statistics

Minimum	106.61473
5-th percentile	106.74443
Q1	106.80175
median	106.83458
Q3	106.88303
95-th percentile	106.94252
Maximum	107.02366
Range	0.40893
Interquartile range (IQR)	0.08128

Descriptive statistics

Standard deviation	0.060999459
Coefficient of variation (CV)	0.00057093555
Kurtosis	0.45242034
Mean	106.84123
Median Absolute Deviation (MAD)	0.03968
Skewness	-0.096326789
Sum	3905688.1
Variance	0.003720934
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
106.87	316	0.8%
106.79203	265	0.7%
106.80188	198	0.5%
106.8657	197	0.5%
106.84213	196	0.5%
106.82286	167	0.4%
106.88165	164	0.4%
106.79844	159	0.4%
106.83102	152	0.4%
106.81949	151	0.4%
Other values (2129)	34591	91.3%
(Missing)	1344	3.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
106.61473	20	0.1%
106.61589	20	0.1%
106.61649	22	0.1%
106.61667	1	< 0.1%
106.61807	41	0.1%
106.61844	1	< 0.1%
106.61918	1	< 0.1%
106.61931	8	< 0.1%
106.62187	20	0.1%
106.63364	2	< 0.1%

Value	Count	Frequency (%)
107.02366	20	0.1%
107.02344	1	< 0.1%
107.02206	1	< 0.1%
107.02205	1	< 0.1%
107.02153	38	0.1%
107.02125	1	< 0.1%
107.02069	20	0.1%
107.0206	8	< 0.1%
107.01988	21	0.1%
107.01858	7	< 0.1%

stopEndSeq
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	74
Distinct (%)	0.2%
Missing	1344
Missing (%)	3.5%
Infinite	0
Infinite (%)	0.0%
Mean	21.219909

Minimum	1
Maximum	77
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	296.2 KiB

Quantile statistics

Minimum	1
5-th percentile	3
Q1	11
median	18
Q3	29
95-th percentile	48
Maximum	77
Range	76
Interquartile range (IQR)	18

Descriptive statistics

Standard deviation	13.800689
Coefficient of variation (CV)	0.65036512
Kurtosis	0.14306451
Mean	21.219909
Median Absolute Deviation (MAD)	8
Skewness	0.81538457
Sum	775715
Variance	190.45901
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
12	1462	3.9%
15	1309	3.5%
13	1297	3.4%
14	1294	3.4%
6	1278	3.4%
16	1268	3.3%
19	1189	3.1%
10	1178	3.1%
18	1167	3.1%
11	1142	3.0%
Other values (64)	23972	63.3%
(Missing)	1344	3.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	732	1.9%
2	694	1.8%
3	568	1.5%
4	739	1.9%
5	933	2.5%
6	1278	3.4%
7	697	1.8%
8	807	2.1%
9	957	2.5%
10	1178	3.1%

Value	Count	Frequency (%)
77	1	< 0.1%
73	19	0.1%
72	1	< 0.1%
71	1	< 0.1%
70	2	< 0.1%
69	9	< 0.1%
68	2	< 0.1%
67	21	0.1%
66	51	0.1%
65	22	0.1%

tapOutTime
Date

MISSING

Distinct	35908
Distinct (%)	98.2%
Missing	1344
Missing (%)	3.5%
Memory size	296.2 KiB

Minimum	2023-04-01 07:27:31
Maximum	2023-04-30 23:23:18

Histogram

Histogram with fixed size bins (bins=50)

payAmount
Categorical

MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	1007
Missing (%)	2.7%
Memory size	296.2 KiB

3500.0	18503
0.0	16648
20000.0	1742

Length

Max length	7
Median length	6
Mean length	4.6934649
Min length	3

Characters and Unicode

Total characters	173156
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3500.0
2nd row	3500.0
3rd row	3500.0
4th row	3500.0
5th row	3500.0

Common Values

Value	Count	Frequency (%)
3500.0	18503	48.8%
0.0	16648	43.9%
20000.0	1742	4.6%
(Missing)	1007	2.7%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
3500.0	18503	50.2%
0.0	16648	45.1%
20000.0	1742	4.7%

Most occurring characters

Value	Count	Frequency (%)
0	97515	56.3%
.	36893	21.3%
3	18503	10.7%
5	18503	10.7%
2	1742	1.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	136263	78.7%
Other Punctuation	36893	21.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	97515	71.6%
3	18503	13.6%
5	18503	13.6%
2	1742	1.3%

Other Punctuation

Value	Count	Frequency (%)
.	36893	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	173156	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	97515	56.3%
.	36893	21.3%
3	18503	10.7%
5	18503	10.7%
2	1742	1.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	173156	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	97515	56.3%
.	36893	21.3%
3	18503	10.7%
5	18503	10.7%
2	1742	1.0%

Auto

Heatmap
Table

	direction	payAmount	payCardBank	payCardBirthDate	payCardID	payCardSex	stopEndSeq	stopStartSeq	tapInStopsLat	tapInStopsLon	tapOutStopsLat	tapOutStopsLon
direction	1.000	0.000	0.000	0.001	-0.001	0.000	-0.035	-0.045	0.005	-0.006	-0.050	0.061
payAmount	0.000	1.000	0.074	0.075	-0.034	0.017	-0.386	-0.265	-0.131	-0.296	-0.130	-0.287
payCardBank	0.000	0.074	1.000	-0.011	-0.636	0.070	-0.008	-0.006	-0.017	0.024	-0.022	0.030
payCardBirthDate	0.001	0.075	-0.011	1.000	-0.030	0.269	-0.023	-0.025	0.053	-0.053	0.034	-0.044
payCardID	-0.001	-0.034	-0.636	-0.030	1.000	0.008	-0.001	0.007	0.027	-0.039	0.024	-0.047
payCardSex	0.000	0.017	0.070	0.269	0.008	1.000	-0.017	-0.012	0.012	0.033	0.017	0.020
stopEndSeq	-0.035	-0.386	-0.008	-0.023	-0.001	-0.017	1.000	0.792	-0.021	0.089	-0.028	0.081
stopStartSeq	-0.045	-0.265	-0.006	-0.025	0.007	-0.012	0.792	1.000	-0.008	0.053	-0.024	0.045
tapInStopsLat	0.005	-0.131	-0.017	0.053	0.027	0.012	-0.021	-0.008	1.000	0.024	0.911	0.033
tapInStopsLon	-0.006	-0.296	0.024	-0.053	-0.039	0.033	0.089	0.053	0.024	1.000	0.033	0.914
tapOutStopsLat	-0.050	-0.130	-0.022	0.034	0.024	0.017	-0.028	-0.024	0.911	0.033	1.000	0.014
tapOutStopsLon	0.061	-0.287	0.030	-0.044	-0.047	0.020	0.081	0.045	0.033	0.914	0.014	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	transID	payCardID	payCardBank	payCardName	payCardSex	payCardBirthDate	corridorID	corridorName	direction	tapInStops	tapInStopsName	tapInStopsLat	tapInStopsLon	stopStartSeq	tapInTime	tapOutStops	tapOutStopsName	tapOutStopsLat	tapOutStopsLon	stopEndSeq	tapOutTime	payAmount
0	EIIW227B8L34VB	180062659848800	emoney	Bajragin Usada	M	2008	5	Matraman Baru - Ancol	1.0	P00142	Pal Putih	-6.184631	106.84402	7	2023-04-03 05:21:44	P00253	Tegalan	-6.203101	106.85715	12.0	2023-04-03 06:00:53	3500.0
1	LGXO740D2N47GZ	4885331907664776	dki	Gandi Widodo	F	1997	6C	Stasiun Tebet - Karet via Patra Kuningan	0.0	B01963P	Kemenkes 2	-6.228700	106.83302	13	2023-04-03 05:42:44	B03307P	Sampoerna Strategic	-6.217152	106.81892	21.0	2023-04-03 06:40:01	3500.0
2	DJWR385V2U57TO	4996225095064169	dki	Emong Wastuti	F	1992	R1A	Pantai Maju - Kota	0.0	B00499P	Gg. Kunir II	-6.133132	106.81435	38	2023-04-03 05:59:06	B04962P	Simpang Kunir Kemukus	-6.133731	106.81475	39.0	2023-04-03 06:50:55	3500.0
3	JTUZ800U7C86EH	639099174703	flazz	Surya Wacana	F	1978	11D	Pulo Gebang - Pulo Gadung 2 via PIK	0.0	B05587P	Taman Elok 1	-6.195743	106.93526	23	2023-04-03 05:44:51	B03090P	Raya Penggilingan	-6.183068	106.93194	29.0	2023-04-03 06:28:16	3500.0
4	VMLO535V7F95NJ	570928206772	flazz	Embuh Mardhiyah	M	1982	12	Tanjung Priok - Pluit	0.0	P00239	Sunter Boulevard Barat	-6.149650	106.88900	5	2023-04-03 06:17:35	P00098	Kali Besar Barat	-6.135355	106.81143	15.0	2023-04-03 06:57:03	3500.0
5	DDES630K2F80KC	2251412124634980	dki	Tirta Siregar	F	1993	1T	Cibubur - Balai Kota	0.0	B00127P	Benhil 3	-6.216010	106.81632	3	2023-04-03 05:08:01	B00694P	Grand Sahid	-6.210975	106.82059	6.0	2023-04-03 05:52:25	20000.0
6	HEMW326B9N91TV	213155822653833	emoney	R. Devi Hariyah, S.T.	M	1974	JAK.18	Kalibata - Kuningan	0.0	B00243P	Cervino Village	-6.224355	106.85165	25	2023-04-03 06:58:21	NaN	NaN	NaN	NaN	NaN	NaN	0.0
7	XTKE052E5E87LN	3587341902618993	dki	Darmanto Rajasa	F	1991	NaN	NaN	1.0	B03416P	SDN Pondok Labu 11	-6.313269	106.80221	2	2023-04-03 06:44:24	B00899P	Jln. Baros	-6.311046	106.78400	12.0	2023-04-03 07:11:43	0.0
8	OIHS248V7S72EB	6510013988638519	dki	Cagak Maheswara, S.Sos	F	1992	B14	Bekasi Barat - Kuningan	1.0	B00795P	Imperium	-6.210363	106.83059	1	2023-04-03 06:01:44	B01853P	Kayuringin 2	-6.245948	106.99247	16.0	2023-04-03 06:51:12	20000.0
9	ERXO372B2H63RB	3580401035990896	dki	T. Dadap Pradana, M.Ak	M	2004	1Q	Rempoa - Blok M	0.0	B05781P	TPU Bungur	-6.247208	106.77889	15	2023-04-03 05:57:47	B06578P	Blok M Jalur 3	-6.243426	106.80188	24.0	2023-04-03 06:51:12	3500.0

	transID	payCardID	payCardBank	payCardName	payCardSex	payCardBirthDate	corridorID	corridorName	direction	tapInStops	tapInStopsName	tapInStopsLat	tapInStopsLon	stopStartSeq	tapInTime	tapOutStops	tapOutStopsName	tapOutStopsLat	tapOutStopsLon	stopEndSeq	tapOutTime	payAmount
37890	GFLN726N6E23SR	213142775112736	emoney	Nadine Waluyo	F	1997	JAK.30	Grogol - Meruya via Roxy	0.0	B00018P	AKR Tower	-6.190732	106.76743	32	2023-04-30 14:45:49	B02471P	MNC Studios	-6.190376	106.76625	33.0	2023-04-30 15:09:39	0.0
37891	XQDZ821C9G88JD	2712823212983860	dki	drg. Maras Wibowo, S.Ked	F	1966	JAK.30	Grogol - Meruya via Roxy	1.0	B01209P	Jln. Kartika Meruya Selatan	-6.203099	106.73673	14	2023-04-19 16:31:09	B04071P	Sbr. Masjid Nurul Falah Grogol	-6.170757	106.78477	53.0	2023-04-19 19:13:53	0.0
37892	YHJT665I6G08OS	4775206940093	online	Cahyo Sudiati, M.Farm	M	1979	JAK.52	Terminal Kalideres - Terminal Muara Angke	1.0	B01087P	Jln. Gunung Galunggung 1	-6.142286	106.73712	29	2023-04-28 16:38:56	B03207P	RSUD Cengkareng	-6.142238	106.73398	30.0	2023-04-28 18:35:16	0.0
37893	GNET512K3A93CA	3500965207195341	dki	Latika Salahudin	F	2000	JAK.80	Rawa Buaya - Rawa Kompeni	0.0	B02485P	MTsN 37	-6.097910	106.70237	39	2023-04-19 08:16:10	B03053P	Puskesmas Kel. Kamal II	-6.100938	106.69786	42.0	2023-04-19 10:32:30	0.0
37894	ZXVG342K6T27GU	4475487986105118550	brizzi	Tgk. Dipa Purnawati, S.E.I	F	2012	JAK.39	Kalimalang - Duren Sawit	0.0	B04489P	Sbr. SMPN 252	-6.239289	106.94229	27	2023-04-14 11:36:12	B01624P	Jln. Swakarsa III Pondok Kelapa	-6.244759	106.94249	35.0	2023-04-14 13:15:25	0.0
37895	ZWEC949B8Q87QG	4685818286724028395	brizzi	Kamila Mahendra	F	2004	6B	Ragunan - MH Thamrin via Semanggi	1.0	P00261	Tosari	-6.196892	106.82309	2	2023-04-21 18:18:37	P00228	SMK 57	-6.290967	106.82365	13.0	2023-04-21 19:55:49	3500.0
37896	YHHK837P6Y95GN	6502902290603767	dki	Titi Siregar	M	1974	9N	Pinang Ranti - Pramuka	1.0	P00064	Garuda Taman Mini	-6.290154	106.88116	1	2023-04-18 21:52:31	P00179	Pinang Ranti	-6.291075	106.88634	2.0	2023-04-18 22:28:22	3500.0
37897	YXPP627N4G95HO	213159426675861	emoney	drg. Zahra Nashiruddin	F	1976	1T	Cibubur - Balai Kota	1.0	B02873P	Plaza Sentral	-6.216247	106.81676	12	2023-04-04 10:29:47	B00226P	Buperta Cibubur	-6.370321	106.89628	14.0	2023-04-04 13:27:25	20000.0
37898	RGVK175U2U98UV	377840859133591	emoney	Ana Agustina	M	1976	JAK.13	Tanah Abang - Jembatan Lima	1.0	B02505P	Museum Textile	-6.188656	106.80954	33	2023-04-15 19:59:26	B01787P	JPO Blok G	-6.188861	106.81135	34.0	2023-04-15 20:27:50	0.0
37899	FMZZ963S4B68ZP	501862539795	flazz	drg. Leo Najmudin	F	1985	13	Ciledug - Tendean	0.0	P00001	Adam Malik	-6.236466	106.74786	2	2023-04-12 21:08:12	P00106	Kebayoran Lama	-6.238340	106.77752	7.0	2023-04-12 21:34:53	3500.0

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Other Punctuation

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Space Separator

Dash Punctuation

Other Punctuation

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script